package com.example.shoppingmall.dao;

import com.example.shoppingmall.pojo.Advertisingcode;
import com.example.shoppingmall.pojo.Advertisingspace;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface AdvertisingspaceMapper {
    //广告位列表：分页显示+条件查询
    public List<Advertisingspace> getAdvertisingspacelist(@Param("name") String name,@Param("utime") String utime,
                                                          @Param("pageno") Integer pageno,@Param("pageSize") Integer pageSize);

    //查询总条数
    public int spacecount(@Param("name") String name,@Param("utime") String utime);

    //查询所有模板
    public List<Advertisingcode> getcodelist();

    //新增广告位列表
    public int addspace(Advertisingspace advertisingspace);

    //查询广告位详情信息
    public Advertisingspace selspace(Integer id);

    //修改广告位列表
    public int updspace(Advertisingspace advertisingspace);

    //删除广告位列表
    public int delspace(Integer id);
}
